package com.amigo.online.provider.video.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Component;

import com.amigo.online.common.core.mybatis.MyMapper;
import com.amigo.online.provider.video.model.entity.AdvApply;

@Mapper
@Component
public interface AdvApplyMapper extends MyMapper<AdvApply> {
	
/*	@Select("select a.id from adv_apply_tbl a, adv_apply_area_tbl b where a.target_area_type = 1 and (a.target_user_sex = 'F' or a.target_user_sex = 'UN')and a.target_user_least_age <= 21 and a.target_user_largest_age >= 21 and a.status = 2 ")
	List<Object> listFindAdvBySexAndAge(@Param("sex")String sex, @Param("age")int age);
	
	@Select("select a.id from adv_apply_tbl a, adv_apply_area_tbl b where a.target_area_type = 2 and a.id = b.adv_id and b.area_id = 2and (a.target_user_sex = 'F' or a.target_user_sex = 'UN')and a.target_user_least_age <= #{} and a.target_user_largest_age >= # and a.status = 2 ")
	List<Object> listFindAdvBySexAndAgeAndArea(@Param("sex")String sex, @Param("age")int age, @Param("cityId")int cityId);

	*/
}
